interview

home / developersection / interviews / what is a "join"?

Ask Question
Pushpendra Singh

Other

Message
Can you answer this question?
Answer

1 Answers

Amit Singh

Amit Singh

30-Oct-2010
The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables. Tables in a database are often related to each other with keys.
A primary key is a column (or a combination of columns) with a unique value for each row. Each primary key value must be unique within the table. The purpose is to bind data together, across tables, without repeating all of the data in every table.

Types of join:

Inner Join
Outer Join
Full Join
Right Join



advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy